 --USE Liberty
--GO
---------------------------------------------------------------------------------------------------
IF (SELECT OBJECT_ID('[GrantManagement].[GetAllGrantStates]')) IS NOT NULL
BEGIN
	DROP PROCEDURE [GrantManagement].[GetAllGrantStates]
END
---------------------------------------------------------------------------------------------------

GO
CREATE PROCEDURE [GrantManagement].[GetAllGrantStates]

AS 

---------------------------------------------------------------------------------------------------
--						Liberty
---------------------------------------------------------------------------------------------------
--  Stored Procedure :: GetAllGrantStates
--                                                                            
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

SELECT 	*
FROM dbo.StatesOfGrant
WHERE Active = 1        
ORDER BY DisplayOrder    

GO

---------------------------------------------------------------------------------------------------
-- Assign appropriate permissions
---------------------------------------------------------------------------------------------------
GRANT EXECUTE ON [GrantManagement].[GetAllGrantStates] TO [Liberty_Users]
GO

